Search results

Listed under:  Mathematics  >  Statistics and probability  >  Data representation  >  Spreadsheets
Online

Spreadsheets come alive

In this lesson sequence use the ‘Odds and evens’ problem as a springboard. Students construct interactive spreadsheets designed to address particular needs. This lesson also demonstrates an approach to programming known as rapid application development (RAD).

Online

Weather forecast from the stratosphere

This lesson sequence is designed to introduce students to data analysis using a spreadsheet such as MS Excel. The project is based on a real world problem and a real data set from a weather balloon launched in Australia earlier this year. The project consists of 5 lessons of variable length, each with a different focus. ...

Online

Turtles: impact of climate change on Flatback turtle populations

The lesson follows an inquiry process in which students use a dataset to answer relevant questions about the turtle population. They consider how to analyse and display the data in order to effectively examine the impact of rising global temperatures on flatback turtle populations.

Online

A spreadsheet's secret weapon

In this lesson sequence, students learn to use pivot tables which have been described as the most powerful tool within spreadsheets.

Text

Faith Lutheran College – Timeline

This document presents the milestones in Faith Lutheran College's participation in the Digital Technologies in Focus project.

Text

St James Catholic College

St James Catholic College is a K–10 school located about 50 kilometres south of Hobart, Tasmania on the Traditional Lands of the Mellukurdee Peoples. Peter Lelong is the curriculum officer who works directly with the school to support the implementation of the Digital Technologies curriculum. Teachers at the school have ...

Text

St James Catholic College – Timeline

This document presents the milestones in St James Catholic College's participation in the Digital Technologies in Focus project.

Text

Digital Technologies resource types and resource mapping template

This three-page document gives suggestions for selecting and organising Digital Technologies resources, including physical equipment, unplugged activities and online links. It includes a simple template that may be helpful in documenting these.

Text

Booth Sweeney review: Systems literacy

This article explores how children’s innate understanding of systems can be developed through deliberate educational programs that support systems thinking. This can happen by encouraging students to identify patterns, consequences and feedback (loops) associated with social, environmental and economic problems; and by ...

Video

DTiF in conversation with Save the Bilby Fund – Background information on the Save the Bilby Fund

Kevin Bradley, CEO of Save the Bilby Fund, and Cassandra Arkinstall, a researcher and volunteer at Save the Bilby Fund, explain why the bilby is an important indicator of the health of an ecosystem, and how their decline impacts other wildlife. This video gives an overview of what the Save the Bilby Fund does as they work ...

Text

Effective DTiF strategies

This PDF lists eight ways in which Digital Technologies in Focus (DTiF) supported the implementation of Digital Technologies in disadvantaged schools.

Text

Newsletter – April 2019

This newsletter from the Digital Technologies in Focus project includes information about school projects, data representation, the Australian Curriculum, and useful resources.

Text

Newsletter – July 2018

This newsletter from the Digital Technologies in Focus project includes information about schools' projects, the Australian Curriculum and useful resources.

Text

Australian Curriculum: Digital Technologies Years 7-8 Sample Assessment Task: Digital Systems - Student activity guide

The Years 7-8 assessment task focuses on digital systems (integrating Digital Technologies and Science). The digital systems assessment task activity guide can teach and assess students’ understanding of how digital systems can be used to monitor the classroom learning environment. Students will learn how to create environmental ...

Text

DTiF Project report

The Leading Curriculum Change Using an Ecosystem Approach: Digital Technologies in focus: Supporting implementation of Digital Technologies evaluation report (June 2021) reports on ACARA’s National Innovation and Science Agenda funded project for the period June 2016 to June 2021. This report is highly relevant to those ...

Online

Protecting dugongs

The Western Australian Marine Science Institution has been collecting data about dugongs off the coast of the Kimberley in Northern WA. We have been provided with the raw data from its sightings trips. In this project students will learn how dugong sightings are conducted, and develop the data-science skills needed to make ...

Online

Hot or not?

This lesson sequence focuses on the incremental or Agile approach to development and encourages students to follow the evolution of a temperature conversion tool for a Food Technology teacher. It uses an Excel spreadsheet application as the prototyping tool.

Text

Easterbrook review: Systems thinking and Computational thinking

This article explores how the relationship between systems thinking and computational thinking would provide a conceptual basis for transformational change – change that considers the social and environmental impact of technology.

Text

Supporting the Implementation of Digital Technologies in Disadvantaged Schools: Case study of impact, outcomes and sustainability (2020)

This PDF is an extensive report on the success of the Digital Technologies in Focus (DTiF) project, with a focus on supporting the Implementation of Digital Technologies in disadvantaged schools. The evaluation gathered qualitative data to create rich case study accounts of six schools' engagement in the project and its ...

Video

Activities that promote Digital Technologies concepts and incorporate Numeracy: part 1: Introduction and overview: accessing the Australian Curriculum National Numeracy Learning progression

This video provides an introduction to the ways in which Digital Technologies can be used to develop students' learning in the Numeracy Learning Progression.